<%@ page language="java" import="java.sql.*"
	contentType="text/html;charset=utf-8"%>
<%
	String path = request.getContextPath();
	String basePath = request.getScheme() + "://" + request.getServerName() + ":" + request.getServerPort()
			+ path + "/";
%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<base href="<%=basePath%>">

<title></title>
<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">

</head>

<body>
	<br>
	<%
		boolean flag = false;
		request.setCharacterEncoding("utf-8");
		String market_id = request.getParameter("market_id");
		String month_index = request.getParameter("month_index");
	%>
	<%
		String driver = "com.mysql.jdbc.Driver";
		String url = "jdbc:mysql://localhost:3306/detecting_system?useUnicode=true&characterEncoding=utf-8";
		String use = "root";
		String password = "";
		Class.forName(driver);
		try{
		Connection conn = DriverManager.getConnection(url, use, password);
		PreparedStatement sql = conn
				.prepareStatement("delete from market_index where market_id=? and month_index=?");
		sql.setString(1, market_id);
		sql.setString(2, month_index);
		int rtn = sql.executeUpdate();
		if (rtn != 0) {
			flag = true;
		}
		sql.close();
		conn.close();
		} catch (Exception ex) {
			ex.printStackTrace();
		}
	%>
	<!-- 判断是否是插入成功 -->
	<%
		if (flag == true) {
	%>
	<jsp:forward page="delete_success.jsp" />
	<%
		} else if (flag == false) {
		out.println("插入失败,5秒后自动跳转回主页面");  
		response.setHeader("refresh","5;url=../login_show.jsp");
	}
	%> 
</body>
</html>
